package com.pulisher.mapper;

import com.pulisher.bean.TradeProvinceCt;
import com.pulisher.bean.TradeScCt;
import org.apache.ibatis.annotations.Select;

import java.math.BigInteger;
import java.util.List;
//@Mapper
public interface TradeStatsMapper {
    @Select("select source_site,sum(order_amount) order_amount from dws_trade_source_window PARTITION (par#{date}) group by source_site")
    List<TradeScCt> selectScAmount(Integer date);

    @Select("select province_name,sum(order_amount) order_amount from dws_trade_province_window PARTITION (par#{date}) group by province_name")
    List<TradeProvinceCt> selectProvinceAmount(Integer date);
}
